How to: Lock windows in position in Excel.
Solution:
Select 'Protection' from the 'Tools' menu, then select 'Protect Workbook...'. Select the 'Windows' check box.
1) Position and size the window as desired.
2) Select the 'Tools' menu and select 'Protection'.
3) Select 'Protect Workbook...' from the submenu. (The Protect Workbook dialog box appears.)
4) Select the 'Windows' check box.
5) (Optional) Type a password to prevent others from removing protection.
NOTE: Passwords may consist of any combination of letters and numbers. Letters are case-sensitive. The password is required to unprotect the document.
6) Click 'OK'.
NOTE: If a password was entered, the 'Confirm Password' dialog box displays. Re-enter the password to confirm it.
